forum

Home / DeveloperSection / Forums / How to get the sum for every distinct value in another column?

Ask Question
Revati S Misra

Revati S Misra

Follow
Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

Aryan Kumar

28-Jul-2023

Sure, you can get the sum for every distinct value in another column using the GROUP BY clause and the SUM() function. The syntax is as follows:

SQL

SELECT distinct_column_name, SUM(column_name)
FROM table_name
GROUP BY distinct_column_name;

For example, if you have a table called products with the columns name and price, you could use the following SQL statement to get the sum of all product prices for each unique product name:

SQL

SELECT name, SUM(price)
FROM products
GROUP BY name;

This would return a table with two columns: name and sum. The name column would contain the unique product names, and the sum column would contain the sum of all product prices for each unique product name.

Here is an example of how to get the sum for every distinct value in another column in MySQL:

SQL

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300),
('Product 1', 400),
('Product 2', 500);

SELECT name, SUM(price)
FROM products
GROUP BY name;

This will return the following result:

name | sum
------+-----
Product 1 | 500
Product 2 | 700
Product 3 | 300

As you can see, the GROUP BY clause has grouped the rows in the products table by the name column. The SUM() function has then been used to calculate the sum of all product prices for each unique product name.

MindStick Training

Liked By